Skip to main content

WINDOW BUFFER

Short Description

Analytical functions use a WINDOW BUFFER to maintain grouping data.

Detailed Description​

Analytical WINDOW function OVER [PARTITION BY] [ORDER BY] requires memory to perform aggregations. WINDOW BUFFER indicates the use of analytical functions in use but no explicit sort has been requested.

Analytical calls can be very useful, but as not everyone understands them, watch out for maintainability and as always - test to ensure they minimise machine load and execution time.

For example:

SELECT
    id
   ,s_3000
   ,LEAD(id) OVER (partition by s_3000)
  FROM t49_53268
 WHERE s_3000 = 1778;

Further Reading​

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.